Time Billing Sales Fields

Time Billing Sales Fields

Field

Description and Character Limits

*Co./Last Name

Must match a preexisting card in your MYOB software data file. If a company name (no first name), 50 characters, alphanumeric. If a last name, 30 characters, alphanumeric. (If the card is an individual, MYOB AccountEdge matches the last name followed by a comma and a space, followed by the first name.)

First Name

20 characters, alphanumeric.

Invoice #

8 characters, alphanumeric

Sale Status

1 alphanumeric character. O indicates an order. Q indicates a quote. Any other character or blank indicates the sale is an invoice.

Purchase Status

1 alphanumeric character. O indicates an order. Q indicates a quote. Any other character or blank indicates the purchase is a bill.

Date

10 characters, alphanumeric. Follows date convention of your system. Allows any non-numeric as a separator between months, days and years.

Already Printed

1 character. Any non-blank character signifies that the invoice is already printed or sent.

Detail Date

10 characters, alphanumeric. Follows date convention of your system. Allows any non-numeric as a separator between months, days and years.

*Activity ID

30 characters, alphanumeric

Hrs/Units

11 characters, numeric (may be negative or blank)

Note

255 characters, alphanumeric

Rate

11 characters, numeric

Amount

15 characters (including dollar sign, comma and negative sign). If no decimal entered, MYOB software appends .00. If more than 2 decimals, MYOB software rounds to the nearest cent.

Job

5 characters, alphanumeric. Must match preexisting job number in your MYOB software data file.

Comment

255 characters, alphanumeric

Journal Memo

255 characters, alphanumeric

Slsmn Last Name

31 characters, alphanumeric. Must match the name of an employee card in the MYOB software data file.

Slsmn First Name

30 characters, alphanumeric.

Promised Date

10 characters, alphanumeric. Follows date convention of your system. Allows any non-numeric as a separator between months, days and years.

Referral Source

20 characters, alphanumeric

Tax Code

3 characters, alphanumeric must match a preexisting tax code in the Tax Code List.

Currency Code

3 characters, alpha. One code per sale/purchase. Must match a preexisting currency code in the Currency List. Must match customer/vendor currency code.

Exchange Rate

11 digits, including 6 decimal places. If blank, current exchange rate substituted.

Sale Status

1 character. O indicates the sale is an order, Q indicates the sale is a quote. Any other character or no character indicates the sale is an invoice.

Purchase Status

1 character. O indicates the purchase is an order, Q indicates the purchase is a quote. Any other character or no character indicates the purchase is an bill.

Terms - Payment is Due

1 character, numeric. Use one of these codes to indicate when payment is due:

0 - COD
1 - Prepaid
2 - In a Given # of Days
3 - On a Day of the Month
4 - # of days after EOM
5 - Day of Month after EOM

- Discount Days

3 characters, numeric
If you choose code 0, 1, 2 or 4 to indicate when payment is due, use a number of days from 0-999.
If you chose code 3 or 5 to indicate when payment is due, use a date from 1-31. (EOM=31)

- Balance Due Days

3 characters, numeric
If you choose code 0, 1, 2 or 4 to indicate when payment is due, use a number of days from 0-999.
If you chose code 3 or 5 to indicate when payment is due, use a date from 1-31. (EOM=31)

- % Discount

2 characters, numeric before a decimal point and 2 characters, numeric after a decimal point.

- % Monthly Charge

2 characters, numeric before a decimal point and 2 characters, numeric after a decimal point.

Amount Paid

15 characters (including dollar sign, comma and negative sign). If no decimal entered, MYOB AccountEdge appends .00. If more than 2 decimals, MYOB software rounds to the nearest cent.

Payment Date

10 characters, alphanumeric. Follows date convention of your system. Allows any non-numeric as a separator between months, days and years.

Payment Method

20 characters, alphanumeric.

Payment Notes

255 characters, alphanumeric. Only available for credit card and debit card methods of payment.

Name on Card

50 characters, alphanumeric. Only available for credit card and debit card methods of payment.

Card Number

25 characters, alphanumeric. Only available for credit card and debit card methods of payment.

Expiration Date

10 characters, alphanumeric. Only available for credit card and debit card methods of payment.

Authorization

255 characters, alphanumeric. Only available for credit card and debit card methods of payment.

*This is a required field for importing.

Field	Description and Character Limits
*Co./Last Name	Must match a preexisting card in your MYOB software data file. If a company name (no first name), 50 characters, alphanumeric. If a last name, 30 characters, alphanumeric. (If the card is an individual, MYOB AccountEdge matches the last name followed by a comma and a space, followed by the first name.)
First Name	20 characters, alphanumeric.
Invoice #	8 characters, alphanumeric
Sale Status	1 alphanumeric character. O indicates an order. Q indicates a quote. Any other character or blank indicates the sale is an invoice.
Purchase Status	1 alphanumeric character. O indicates an order. Q indicates a quote. Any other character or blank indicates the purchase is a bill.
Date	10 characters, alphanumeric. Follows date convention of your system. Allows any non-numeric as a separator between months, days and years.
Already Printed	1 character. Any non-blank character signifies that the invoice is already printed or sent.
Detail Date	10 characters, alphanumeric. Follows date convention of your system. Allows any non-numeric as a separator between months, days and years.
*Activity ID	30 characters, alphanumeric
Hrs/Units	11 characters, numeric (may be negative or blank)
Note	255 characters, alphanumeric
Rate	11 characters, numeric
Amount	15 characters (including dollar sign, comma and negative sign). If no decimal entered, MYOB software appends .00. If more than 2 decimals, MYOB software rounds to the nearest cent.
Job	5 characters, alphanumeric. Must match preexisting job number in your MYOB software data file.
Comment	255 characters, alphanumeric
Journal Memo	255 characters, alphanumeric
Slsmn Last Name	31 characters, alphanumeric. Must match the name of an employee card in the MYOB software data file.
Slsmn First Name	30 characters, alphanumeric.
Promised Date	10 characters, alphanumeric. Follows date convention of your system. Allows any non-numeric as a separator between months, days and years.
Referral Source	20 characters, alphanumeric
Tax Code	3 characters, alphanumeric must match a preexisting tax code in the Tax Code List.
Currency Code	3 characters, alpha. One code per sale/purchase. Must match a preexisting currency code in the Currency List. Must match customer/vendor currency code.
Exchange Rate	11 digits, including 6 decimal places. If blank, current exchange rate substituted.
Sale Status	1 character. O indicates the sale is an order, Q indicates the sale is a quote. Any other character or no character indicates the sale is an invoice.
Purchase Status	1 character. O indicates the purchase is an order, Q indicates the purchase is a quote. Any other character or no character indicates the purchase is an bill.
Terms - Payment is Due	1 character, numeric. Use one of these codes to indicate when payment is due: 0 - COD 1 - Prepaid 2 - In a Given # of Days 3 - On a Day of the Month 4 - # of days after EOM 5 - Day of Month after EOM
- Discount Days	3 characters, numeric If you choose code 0, 1, 2 or 4 to indicate when payment is due, use a number of days from 0-999. If you chose code 3 or 5 to indicate when payment is due, use a date from 1-31. (EOM=31)
- Balance Due Days	3 characters, numeric If you choose code 0, 1, 2 or 4 to indicate when payment is due, use a number of days from 0-999. If you chose code 3 or 5 to indicate when payment is due, use a date from 1-31. (EOM=31)
- % Discount	2 characters, numeric before a decimal point and 2 characters, numeric after a decimal point.
- % Monthly Charge	2 characters, numeric before a decimal point and 2 characters, numeric after a decimal point.
Amount Paid	15 characters (including dollar sign, comma and negative sign). If no decimal entered, MYOB AccountEdge appends .00. If more than 2 decimals, MYOB software rounds to the nearest cent.
Payment Date	10 characters, alphanumeric. Follows date convention of your system. Allows any non-numeric as a separator between months, days and years.
Payment Method	20 characters, alphanumeric.
Payment Notes	255 characters, alphanumeric. Only available for credit card and debit card methods of payment.
Name on Card	50 characters, alphanumeric. Only available for credit card and debit card methods of payment.
Card Number	25 characters, alphanumeric. Only available for credit card and debit card methods of payment.
Expiration Date	10 characters, alphanumeric. Only available for credit card and debit card methods of payment.
Authorization	255 characters, alphanumeric. Only available for credit card and debit card methods of payment.